﻿using System.Collections.Generic;

namespace Citi.FinancePlanningAnalysis.Domain
{
    public partial class PMFAccount
    {
        #region Mappings

        public static readonly Dictionary<string, string> ExcelColumnMappings = new Dictionary<string, string> { 
                {"[Parent PMF Account Code]", "[ParentCode]"},
                {"[PMF Account Code]", "[Code]"},
                {"[Status]", "[Status]"},
                {"[Data Class]", "[DataClass]"},
                {"[Description]", "[Description]"},
                {"[Long Description]", "[LongDescription]"},
                {"[Effective Date]", "[EffectiveDate]"}
            };
        					
        #endregion

        public const string QueryMergeDate = "EXEC sp_MergeAllPMFAccount";
        public const string QueryDeletePrevious = "DELETE FROM PMFAccountTemp";

        public const string QueryExcel = @"SELECT 
                    [Parent PMF Account Code],
                    [PMF Account Code],
                    [Status],
                    [Data Class],
                    [Description],
                    [Long Description],
                    [Effective Date]
                FROM [{0}$]";
    }
}
